Quản lý website giới thiệu và bán điện thoại di động ASP.net
19.302 lượt xem;
- thanhtoan.aspx.cs
- project /
1 using System;
2 using System.Collections;
3 using System.Configuration;
4 using System.Data;
5 using System.Linq;
6 using System.Web;
7 using System.Web.Security;
8 using System.Web.UI;
9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13 using System.Data.OleDb;
14
15 public partial class _Default : System.Web.UI.Page
16 {
17 DataTable tb; string s; System.IO.StreamReader sr1; System.IO.StreamWriter sw1;
18 protected void Page_Load(object sender, EventArgs e)
19 {
20 if ((Session["diachi"] != null) && (Session["hoten"] != null))
21 {
22 Panel1.Visible = true;
23 Panel2.Visible = false;
24 tb = (DataTable)Session["hangmua"];
25 GridView1.DataSource = tb;
26 GridView1.DataBind();
27 lbtien.Text = Session["tong"].ToString() + "VND";
28 }
29 }
30
31
32 protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
33 {
34
35 }
36 protected void imdangnhap_Click(object sender, ImageClickEventArgs e)
37 {
38 Session["dn"] = "kk";
39 Response.Redirect("dangnhap.aspx", true);
40 }
41
42
43 protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
44 {
45 if(Session["email"]!=null)
46 {
47 Panel3.Visible = true;
48 ado.ketNoi();
49 string ngay = System.DateTime.Now.ToString();
50 ngay = ngay.Substring(0, ngay.IndexOf(" "));
51 string sql = "insert into tbldondathang(email,dcgiaohang,htgiaohang,htthanhtoan,ngaydat,ngaygiao) values('"+Session["email"].ToString()+"','"+txtdcgiaohang.Text+"','"+txtgiaohang.Text+"','"+DropDownList1.Text+"','"+ngay+"','"+txtngaygiao.Text+"')";
52 OleDbCommand cmd = new OleDbCommand(sql,ado.con);
53 cmd.ExecuteNonQuery();
54
55 sr1 = new System.IO.StreamReader(Server.MapPath("App_Data/thanhtoan.txt"));
56 s = sr1.ReadLine();
57 int t = int.Parse(s.ToString()) + 1;
58 sr1.Close();
59
60 foreach (DataRow r in tb.Rows)
61 {
62
63 string sql1 = "insert into tblhoadontt(maddh,masp,soluong,gia) values('" + t.ToString() + "','" + r[0].ToString() + "','" + r[1].ToString() + "','" + r[2].ToString() + "')";
64 OleDbCommand cmd1 = new OleDbCommand(sql1, ado.con);
65 cmd1.ExecuteNonQuery();
66
67 }
68
69 sw1 = new System.IO.StreamWriter(Server.MapPath("App_Data/thanhtoan.txt"));
70 sw1.Write(t.ToString());
71 sw1.Close();
72
73
74 }
75 }
76 }
2 using System.Collections;
3 using System.Configuration;
4 using System.Data;
5 using System.Linq;
6 using System.Web;
7 using System.Web.Security;
8 using System.Web.UI;
9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13 using System.Data.OleDb;
14
15 public partial class _Default : System.Web.UI.Page
16 {
17 DataTable tb; string s; System.IO.StreamReader sr1; System.IO.StreamWriter sw1;
18 protected void Page_Load(object sender, EventArgs e)
19 {
20 if ((Session["diachi"] != null) && (Session["hoten"] != null))
21 {
22 Panel1.Visible = true;
23 Panel2.Visible = false;
24 tb = (DataTable)Session["hangmua"];
25 GridView1.DataSource = tb;
26 GridView1.DataBind();
27 lbtien.Text = Session["tong"].ToString() + "VND";
28 }
29 }
30
31
32 protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
33 {
34
35 }
36 protected void imdangnhap_Click(object sender, ImageClickEventArgs e)
37 {
38 Session["dn"] = "kk";
39 Response.Redirect("dangnhap.aspx", true);
40 }
41
42
43 protected void ImageButton3_Click(object sender, ImageClickEventArgs e)
44 {
45 if(Session["email"]!=null)
46 {
47 Panel3.Visible = true;
48 ado.ketNoi();
49 string ngay = System.DateTime.Now.ToString();
50 ngay = ngay.Substring(0, ngay.IndexOf(" "));
51 string sql = "insert into tbldondathang(email,dcgiaohang,htgiaohang,htthanhtoan,ngaydat,ngaygiao) values('"+Session["email"].ToString()+"','"+txtdcgiaohang.Text+"','"+txtgiaohang.Text+"','"+DropDownList1.Text+"','"+ngay+"','"+txtngaygiao.Text+"')";
52 OleDbCommand cmd = new OleDbCommand(sql,ado.con);
53 cmd.ExecuteNonQuery();
54
55 sr1 = new System.IO.StreamReader(Server.MapPath("App_Data/thanhtoan.txt"));
56 s = sr1.ReadLine();
57 int t = int.Parse(s.ToString()) + 1;
58 sr1.Close();
59
60 foreach (DataRow r in tb.Rows)
61 {
62
63 string sql1 = "insert into tblhoadontt(maddh,masp,soluong,gia) values('" + t.ToString() + "','" + r[0].ToString() + "','" + r[1].ToString() + "','" + r[2].ToString() + "')";
64 OleDbCommand cmd1 = new OleDbCommand(sql1, ado.con);
65 cmd1.ExecuteNonQuery();
66
67 }
68
69 sw1 = new System.IO.StreamWriter(Server.MapPath("App_Data/thanhtoan.txt"));
70 sw1.Write(t.ToString());
71 sw1.Close();
72
73
74 }
75 }
76 }